﻿
-- Changement de la colonne CreatedOn de NodeInstance de NULL en NOT NULL
Update medianamik_NodeInstance 
SET CreatedOn = n.CreatedOn 
From medianamik_NodeInstance ni Join Medianamik_Node n ON n.NodeId = ni.NodeId
WHERE ni.CreatedOn IS NULL

alter table medianamik_NodeInstance
alter column CreatedOn datetime NOT NULL
